Microsoft SharePoint 2010 Business Intelligence Unleashed (Pioneer Panel's Library) by Steven Mann & Chuck Rivel & Ray Barley & Jim Pletscher & Aneel Ismaily
Author:Steven Mann & Chuck Rivel & Ray Barley & Jim Pletscher & Aneel Ismaily
Language: eng
Format: epub
Publisher: Sams Publishing
Published: 2011-06-14T16:00:00+00:00
The ETLLoadID, LoadDate, and UpdateDate columns are fields that don’t provide analytic value. Clear the check box in front of these fields so that they aren’t imported. Click OK to apply the filters to the DimGeography table.
Back on the Select Tables and Views dialog, notice that DimGeography now lists Applied Filters in the Filter Details column. This makes it easy to see which dimensions have filtering in place. You can also click the Preview and Filter button again to further modify the filtering options if necessary.
Select the check box next to the following tables to include them in the data model: • DimDate
• DimProduct
• DimProductCategory
• DimProductSubCategory
• DimStore
• FactSales
Then click Finish.
The data import begins and a status box displays the status of each of the tables, as shown in Figure 9.6. Notice that PowerPivot can work with large datasets; more than three million records were imported from the fact table, and done quickly!
Figure 9.6. Import results.
Download
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
Implementing Enterprise Observability for Success by Manisha Agrawal and Karun Krishnannair(7425)
Supercharging Productivity with Trello by Brittany Joiner(6685)
Mastering Tableau 2023 - Fourth Edition by Marleen Meier(6451)
Secrets of the JavaScript Ninja by John Resig Bear Bibeault(6425)
Inkscape by Example by István Szép(6303)
Visualize Complex Processes with Microsoft Visio by David J Parker & Šenaj Lelić(5998)
Build Stunning Real-time VFX with Unreal Engine 5 by Hrishikesh Andurlekar(5001)
Design Made Easy with Inkscape by Christopher Rogers(4648)
Customizing Microsoft Teams by Gopi Kondameda(4187)
Linux Device Driver Development Cookbook by Rodolfo Giometti(3941)
Business Intelligence Career Master Plan by Eduardo Chavez & Danny Moncada(3788)
Extending Microsoft Power Apps with Power Apps Component Framework by Danish Naglekar(3774)
Salesforce Platform Enterprise Architecture - Fourth Edition by Andrew Fawcett(3653)
Pandas Cookbook by Theodore Petrou(3629)
The Tableau Workshop by Sumit Gupta Sylvester Pinto Shweta Sankhe-Savale JC Gillet and Kenneth Michael Cherven(3428)
TCP IP by Todd Lammle(2995)
Drawing Shortcuts: Developing Quick Drawing Skills Using Today's Technology by Leggitt Jim(2925)
Exploring Microsoft Excel's Hidden Treasures by David Ringstrom(2898)
Applied Predictive Modeling by Max Kuhn & Kjell Johnson(2885)
